/*
 Navicat Premium Data Transfer

 Source Server         : 测试192.168.243.20
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : 192.168.243.20:9097
 Source Schema         : boa_monitoring

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 24/01/2024 08:40:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for boa_menu
-- ----------------------------
DROP TABLE IF EXISTS `boa_menu`;
CREATE TABLE `boa_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `url` varchar(200) COLLATE utf8mb4_bin DEFAULT '#' COMMENT '请求地址',
  `target` varchar(20) COLLATE utf8mb4_bin DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）',
  `menu_type` char(1) COLLATE utf8mb4_bin DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `is_refresh` char(1) COLLATE utf8mb4_bin DEFAULT '1' COMMENT '是否刷新（0刷新 1不刷新）',
  `perms` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) COLLATE utf8mb4_bin DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT '' COMMENT '备注',
  `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `component_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组件名称',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统管理-菜单权限表';

-- ----------------------------
-- Records of boa_menu
-- ----------------------------
BEGIN;
INSERT INTO `boa_menu` VALUES (1, '系统管理', 0, 1, '/admin', 'menuItem', 'M', '0', '1', 'admin', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 16:04:59', '系统管理', '0', NULL);
INSERT INTO `boa_menu` VALUES (2, '探针服务', 0, 2, '/pworker', 'menuItem', 'M', '0', '1', 'pworker', 'iconfont bm-fujian', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 14:39:37', '探针服务', '0', NULL);
INSERT INTO `boa_menu` VALUES (3, '检测服务', 0, 3, '/detection', 'menuItem', 'M', '0', '1', 'detection', 'iconfont bm-jiance', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 14:41:55', '检测服务', '0', NULL);
INSERT INTO `boa_menu` VALUES (4, '分发服务', 0, 4, '/distribute', 'menuItem', 'M', '0', '1', 'distribute', 'iconfont bm-fenfa2', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 14:45:03', '分发服务', '0', NULL);
INSERT INTO `boa_menu` VALUES (5, '开放服务', 0, 5, '/openup', 'menuItem', 'M', '0', '1', 'openup', 'iconfont bm-kaifang', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 14:46:19', '开放服务', '0', NULL);
INSERT INTO `boa_menu` VALUES (6, '数据中心基础设施监控', 0, 6, '/infrastructure', 'menuItem', 'M', '0', '1', 'infrastructure', 'iconfont bm-basic-info', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:10:12', '数据中心基础设施监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (7, '源端数据库监控', 0, 7, '/sourceDatabase', 'menuItem', 'M', '0', '1', 'sourceDatabase', 'iconfont bm-source', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:13:07', '源端数据库监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (8, '数据采集监控', 0, 8, '/dataCollection', 'menuItem', 'M', '0', '1', 'dataCollection', 'iconfont bm-shujucaiji', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:15:07', '数据采集监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (9, '大数据底座监控', 0, 9, '/bidata', 'menuItem', 'M', '0', '1', 'bidata', 'iconfont bm-dashuju', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:18:06', '大数据底座监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (10, '数据开发平台监控', 0, 10, '/devPaltform', 'menuItem', 'M', '0', '1', 'devPaltform', 'iconfont bm-kaifangpingtai', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:21:34', '开发平台监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (11, '数据治理监控', 0, 11, '/dataGov', 'menuItem', 'M', '0', '1', 'dataGov', 'iconfont bm-shujuzhili', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:23:56', '数据治理监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (12, '分析性数据库监控', 0, 12, '/analyDatabase', 'menuItem', 'M', '0', '1', 'analyDatabase', 'iconfont bm-fenxi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:29:58', '分析性数据库监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (13, '数据可视化监控', 0, 13, '/dataVis', 'menuItem', 'M', '0', '1', 'dataVis', 'iconfont bm-shujukeshihua', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-09 15:32:54', '数据可视化监控', '0', NULL);
INSERT INTO `boa_menu` VALUES (14, '部门管理', 1, 1, '/department/list', 'menuItem', 'C', '0', '1', 'dept', 'iconfont bm-bumen', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-11 17:35:44', '部门', '0', '/Admin/Department/list');
INSERT INTO `boa_menu` VALUES (15, '用户管理', 1, 2, '/user/list', 'menuItem', 'C', '0', '1', 'user', 'iconfont bm-yonghuguanli', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:18:30', '用户', '0', '/Admin/User/list');
INSERT INTO `boa_menu` VALUES (16, '岗位管理', 1, 3, '/post/list', 'menuItem', 'C', '0', '1', 'post', 'iconfont bm-gangwei', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:20:16', '岗位', '0', '/Admin/Post/list');
INSERT INTO `boa_menu` VALUES (17, '角色管理', 1, 4, '/role/list', 'menuItem', 'C', '0', '1', 'role', 'iconfont bm-jiaoseguanli', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:21:22', '角色', '0', '/Admin/Role/list');
INSERT INTO `boa_menu` VALUES (18, '菜单管理', 1, 5, '/menu/list', 'menuItem', 'C', '0', '1', 'menu', 'iconfont bm-caidanguanli', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:15:05', '菜单', '0', '/Admin/Menu/list');
INSERT INTO `boa_menu` VALUES (19, '字典类型', 1, 6, '/dict/type', 'menuItem', 'C', '0', '1', 'dicttype', 'iconfont bm-zidianguanli', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:21:47', '字典类型', '0', '/Admin/Dict/type');
INSERT INTO `boa_menu` VALUES (20, '字典数据', 1, 7, '/dict/data', 'menuItem', 'C', '0', '1', 'dictdata', 'iconfont bm-zidianguanli', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:22:06', '字典数据', '0', '/Admin/Dict/data');
INSERT INTO `boa_menu` VALUES (21, '参数配置', 1, 8, '/param/setting', 'menuItem', 'C', '0', '1', 'config', 'iconfont bm-canshuguanli', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:22:29', '参数配置', '0', '/Admin/Param/setting');
INSERT INTO `boa_menu` VALUES (22, '操作日志', 1, 9, '/operlog/list', 'menuItem', 'C', '0', '1', '1', 'iconfont bm-rizhiguanli', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:24:56', '操作日志', '0', '/Admin/Operlog/list');
INSERT INTO `boa_menu` VALUES (23, '探针执行器', 2, 1, '/pworker/actuator', 'menuItem', 'C', '0', '1', 'actuator', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:45:49', '探针执行器', '0', '/Monitor/BPS/Pworker/actuator');
INSERT INTO `boa_menu` VALUES (24, '监控对象', 2, 2, '/pworker/object', 'menuItem', 'C', '0', '1', 'object', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:46:34', '监控对象', '0', '/Monitor/BPS/Pworker/object');
INSERT INTO `boa_menu` VALUES (25, '探针控制台', 2, 3, '/pworker/console', 'menuItem', 'C', '0', '1', 'console', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-12 15:46:03', '探针控制台', '0', '/Monitor/BPS/Pworker/console');
INSERT INTO `boa_menu` VALUES (26, '服务器状态', 6, 1, '/infrastructure/serverStatus', 'menuItem', 'C', '0', '1', 'infrastructure', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-13 10:38:39', '服务器状态', '0', '/Info/Infrastructure/server');
INSERT INTO `boa_menu` VALUES (27, '网络状态', 6, 2, '/infrastructure/networkStatus', 'menuItem', 'C', '0', '1', 'infrastructure', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-13 10:38:56', '网络状态', '0', '/Info/Infrastructure/network');
INSERT INTO `boa_menu` VALUES (28, '数据库状态', 7, 1, '/sourceDatabase/dbstatus', 'menuItem', 'C', '0', '1', 'sourceDatabase', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-13 10:39:57', '数据库状态', '0', '/Info/SourceDatabase/dbstatus');
INSERT INTO `boa_menu` VALUES (29, 'HDFS状态', 9, 1, '/bigdata/hdfsStatus', 'menuItem', 'C', '0', '1', 'bigdata', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-13 10:41:28', 'HDFS状态', '0', '/Info/Bigdata/hdfsStatus');
INSERT INTO `boa_menu` VALUES (30, 'YARN状态', 9, 2, '/bigdata/yarnStatus', 'menuItem', 'C', '0', '1', 'bigdata', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-13 10:41:53', 'YARN状态', '0', '/Info/Bigdata/yarnStatus');
INSERT INTO `boa_menu` VALUES (31, 'Impala状态', 9, 3, '/bigdata/impalaStatus', 'menuItem', 'C', '0', '1', 'bigdata', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-13 10:42:17', 'Impala状态', '0', '/Info/Bigdata/impalaStatus');
INSERT INTO `boa_menu` VALUES (32, '新调度系统状态', 10, 2, '/devPaltform/schedStatus', 'menuItem', 'C', '0', '1', 'devPaltform', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-20 09:56:10', '新调度系统状态', '0', '/Info/DevPlatform/schedStatus');
INSERT INTO `boa_menu` VALUES (33, '旧调度系统状态', 10, 3, '/devPaltform/oldSchedStatus', 'menuItem', 'C', '0', '1', 'devPaltform', 'iconfont bm-liebiaomoshi', 'admin', '2022-09-13 15:53:00', 'admin', '2022-10-20 09:56:16', '旧调度系统状态', '0', '/Info/DevPlatform/oldSchedStatus');
INSERT INTO `boa_menu` VALUES (36, '首页', 0, 0, '/home/index', 'menuItem', 'M', '0', '1', 'home', 'iconfont bm-shouye', 'admin', '2022-10-09 14:28:21', 'admin', '2022-10-11 17:11:03', '', '0', '/Admin/Department/list');
INSERT INTO `boa_menu` VALUES (37, '概况分析', 3, 0, '/detection/analy', 'menuItem', 'C', '0', '1', 'detection', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 14:43:26', 'admin', '2022-10-13 10:12:59', '', '0', '/Info/Detection/analy');
INSERT INTO `boa_menu` VALUES (38, '概况分析', 4, 0, '/distribute/analy', 'menuItem', 'C', '0', '1', 'distribute', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 14:45:47', 'admin', '2022-10-13 10:14:19', '', '0', '/Info/Distribute/analy');
INSERT INTO `boa_menu` VALUES (39, '概况分析', 5, 0, '/openup/analy', 'menuItem', 'C', '0', '1', 'openup', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 14:47:11', 'admin', '2022-10-13 10:35:13', '', '0', '/Info/OpenUp/analy');
INSERT INTO `boa_menu` VALUES (40, '概况分析', 6, 0, '/infrastructure/analy', 'menuItem', 'C', '0', '1', 'infrastructure', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:11:15', 'admin', '2022-10-13 10:38:15', '', '0', '/Info/Infrastructure/analy');
INSERT INTO `boa_menu` VALUES (41, '概况分析', 7, 0, '/sourceDatabase/analy', 'menuItem', 'C', '0', '1', 'sourceDatabase', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:14:01', 'admin', '2022-10-13 10:39:30', '', '0', '/Info/SourceDatabase/analy');
INSERT INTO `boa_menu` VALUES (42, '概况分析', 8, 0, '/dataCollection/analy', 'menuItem', 'C', '0', '1', 'dataCollection', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:17:37', 'admin', '2022-10-13 10:40:35', '', '0', '/Info/DataCollection/analy');
INSERT INTO `boa_menu` VALUES (43, '概况分析', 9, 0, '/bidata/analy', 'menuItem', 'C', '0', '1', 'bidata', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:19:05', 'admin', '2022-10-13 10:41:07', '', '0', '/Info/Bigdata/analy');
INSERT INTO `boa_menu` VALUES (44, '概况分析', 10, 0, '/devPaltform/analy', 'menuItem', 'C', '0', '1', 'devPaltform', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:22:27', 'admin', '2022-10-13 10:42:49', '', '0', '/Info/DevPlatform/analy');
INSERT INTO `boa_menu` VALUES (45, '概况分析', 11, 0, '/dataGov/analy', 'menuItem', 'C', '0', '1', 'dataGov', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:24:54', 'admin', '2022-10-13 10:44:00', '', '0', '/Info/DataGov/analy');
INSERT INTO `boa_menu` VALUES (46, '新调度离线作业', 11, 1, '/dataGov/schedOfflineJob', 'menuItem', 'C', '0', '1', 'dataGov', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:25:44', 'admin', '2022-10-13 10:44:31', '', '0', '/Info/DataGov/schedOfflineJobStatus');
INSERT INTO `boa_menu` VALUES (47, '旧调度读取Impala超标量', 11, 2, '/dataGov/oldSchedImpalaExceed', 'menuItem', 'C', '0', '1', 'dataGov', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:26:29', 'admin', '2022-10-13 10:44:53', '', '0', '/Info/DataGov/oldSchedImpalaExceed');
INSERT INTO `boa_menu` VALUES (48, '概况分析', 12, 0, '/analyDatabase/analy', 'menuItem', 'C', '0', '1', 'analyDatabase', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:31:11', 'admin', '2022-10-13 10:45:19', '', '0', '/Info/AnalyDatabase/analy');
INSERT INTO `boa_menu` VALUES (49, 'Redis状态', 12, 1, '/analyDatabase/redisStatus', 'menuItem', 'C', '0', '1', 'analyDatabase', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:31:55', 'admin', '2022-10-13 10:45:43', '', '0', '/Info/AnalyDatabase/redisStatus');
INSERT INTO `boa_menu` VALUES (50, 'PG业务库复制延迟', 12, 2, '/analyDatabase/pgSlaveStatus', 'menuItem', 'C', '0', '1', 'analyDatabase', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:32:27', 'admin', '2022-10-13 10:46:01', '', '0', '/Info/AnalyDatabase/pgSlaveStatus');
INSERT INTO `boa_menu` VALUES (51, '帆软报表概况分析', 13, 0, '/dataVis/analy', 'menuItem', 'C', '0', '1', 'dataVis', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-09 15:33:30', 'admin', '2022-11-04 15:13:53', '', '0', '/Info/DataVis/analy');
INSERT INTO `boa_menu` VALUES (52, '新增', 0, 0, '/menu/list', 'menuItem', 'M', '0', '0', '1', '1', 'admin', '2022-10-11 10:21:36', 'admin', '2022-10-11 10:24:08', '', '1', NULL);
INSERT INTO `boa_menu` VALUES (53, '副业', 36, 1, '/menu/list', 'menuBlank', 'M', '0', '0', '1', '1', 'admin', '2022-10-11 10:27:03', 'admin', '2022-10-11 10:27:44', '', '1', NULL);
INSERT INTO `boa_menu` VALUES (54, '权限管理', 1, 10, '/list', 'menuItem', 'C', '0', '1', 'power', '14', 'admin', '2022-10-11 10:28:29', 'admin', '2022-10-11 10:29:59', '', '1', NULL);
INSERT INTO `boa_menu` VALUES (55, '11', 1, 0, '1', 'menuItem', 'M', '0', '0', '1', '1', 'admin', '2022-10-11 13:40:32', 'admin', '2022-10-11 13:40:32', '', '1', NULL);
INSERT INTO `boa_menu` VALUES (56, '权限', 1, 0, '1', 'menuItem', 'C', '0', '0', '1', '1', 'admin', '2022-10-11 14:00:32', 'admin', '2022-10-11 14:00:32', '', '1', NULL);
INSERT INTO `boa_menu` VALUES (57, '副页', 36, 0, '/menu/list', 'menuItem', 'M', '0', '0', '2', 'iconfont bm-rizhiguanli', 'admin', '2022-10-11 14:07:29', 'admin', '2022-10-11 14:07:29', '', '1', NULL);
INSERT INTO `boa_menu` VALUES (58, '23', 1, 0, '32', 'menuItem', 'M', '0', '1', '23', '323', 'admin', '2022-10-11 14:11:19', 'admin', '2022-10-11 14:11:19', '', '1', NULL);
INSERT INTO `boa_menu` VALUES (59, '新调度概况分析', 10, 1, '/devPlatform/schedAnaly', 'menuItem', 'C', '0', '0', 'schedAnaly', 'iconfont bm-liebiaomoshi', 'admin', '2022-10-20 09:55:39', 'admin', '2022-11-08 14:05:47', '', '0', '/Info/DevPlatform/schedAnaly');
INSERT INTO `boa_menu` VALUES (60, 'BI报表概况分析', 13, 1, '/dataVis/BIanaly', 'menuItem', 'C', '0', '1', 'dataVis', 'iconfont bm-liebiaomoshi', 'admin', '2022-11-04 14:51:01', 'admin', '2022-11-04 15:14:08', '', '0', '/Info/DataVis/BIanaly');
COMMIT;

-- ----------------------------
-- Table structure for boa_role
-- ----------------------------
DROP TABLE IF EXISTS `boa_role`;
CREATE TABLE `boa_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) COLLATE utf8mb4_bin DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `status` char(1) COLLATE utf8mb4_bin NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统管理-角色信息表';

-- ----------------------------
-- Records of boa_role
-- ----------------------------
BEGIN;
INSERT INTO `boa_role` VALUES (1, '超级管理员', 'admin', 1, '1', '0', '0', 'admin', '2022-03-16 08:55:04', '', NULL, '超级管理员');
INSERT INTO `boa_role` VALUES (2, '普通角色', 'common', 2, '2', '0', '0', 'admin', '2022-03-16 08:55:04', '', NULL, '普通角色');
INSERT INTO `boa_role` VALUES (100, '角色111', 'juese111', 11, '1', '1', '1', '', '2022-03-21 17:33:05', '', '2022-03-21 17:33:05', '112233');
INSERT INTO `boa_role` VALUES (102, '角色222', 'juese222', 11, '1', '1', '1', '', '2022-03-22 10:19:53', '', '2022-03-22 10:48:42', '112233');
INSERT INTO `boa_role` VALUES (103, '角色111', 'juese111', 11, '1', '1', '1', '', '2022-03-22 10:23:48', '', '2022-03-22 10:23:48', '112233');
INSERT INTO `boa_role` VALUES (104, '角色111', 'juese111', 11, '1', '1', '1', '', '2022-03-24 11:07:29', '', '2022-03-24 11:07:29', '112233');
INSERT INTO `boa_role` VALUES (105, '1234', '14134', 325, '1', '0', '1', NULL, '2022-09-27 11:46:55', NULL, '2022-09-28 14:54:22', '');
INSERT INTO `boa_role` VALUES (106, '11154545', '11', 327, '1', '0', '1', NULL, '2022-09-28 08:52:08', NULL, '2022-09-28 14:54:29', '');
INSERT INTO `boa_role` VALUES (107, '12', '23', 328, '2', '0', '1', NULL, '2022-09-28 14:53:38', NULL, '2022-09-28 14:53:38', '');
INSERT INTO `boa_role` VALUES (108, '分级管理员', 'manage', 3, '2', '0', '0', 'admin', '2023-05-31 14:00:03', 'admin', '2023-05-31 14:00:03', '');
COMMIT;

-- ----------------------------
-- Table structure for boa_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `boa_role_menu`;
CREATE TABLE `boa_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统管理-角色和菜单关联表';

-- ----------------------------
-- Records of boa_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `boa_role_menu` VALUES (1, 1);
INSERT INTO `boa_role_menu` VALUES (1, 2);
INSERT INTO `boa_role_menu` VALUES (1, 3);
INSERT INTO `boa_role_menu` VALUES (1, 4);
INSERT INTO `boa_role_menu` VALUES (1, 5);
INSERT INTO `boa_role_menu` VALUES (1, 6);
INSERT INTO `boa_role_menu` VALUES (1, 7);
INSERT INTO `boa_role_menu` VALUES (1, 8);
INSERT INTO `boa_role_menu` VALUES (1, 9);
INSERT INTO `boa_role_menu` VALUES (1, 10);
INSERT INTO `boa_role_menu` VALUES (1, 11);
INSERT INTO `boa_role_menu` VALUES (1, 12);
INSERT INTO `boa_role_menu` VALUES (1, 13);
INSERT INTO `boa_role_menu` VALUES (1, 14);
INSERT INTO `boa_role_menu` VALUES (1, 15);
INSERT INTO `boa_role_menu` VALUES (1, 16);
INSERT INTO `boa_role_menu` VALUES (1, 17);
INSERT INTO `boa_role_menu` VALUES (1, 18);
INSERT INTO `boa_role_menu` VALUES (1, 19);
INSERT INTO `boa_role_menu` VALUES (1, 20);
INSERT INTO `boa_role_menu` VALUES (1, 21);
INSERT INTO `boa_role_menu` VALUES (1, 22);
INSERT INTO `boa_role_menu` VALUES (1, 23);
INSERT INTO `boa_role_menu` VALUES (1, 24);
INSERT INTO `boa_role_menu` VALUES (1, 25);
INSERT INTO `boa_role_menu` VALUES (1, 26);
INSERT INTO `boa_role_menu` VALUES (1, 27);
INSERT INTO `boa_role_menu` VALUES (1, 28);
INSERT INTO `boa_role_menu` VALUES (1, 29);
INSERT INTO `boa_role_menu` VALUES (1, 30);
INSERT INTO `boa_role_menu` VALUES (1, 31);
INSERT INTO `boa_role_menu` VALUES (1, 32);
INSERT INTO `boa_role_menu` VALUES (1, 33);
INSERT INTO `boa_role_menu` VALUES (1, 36);
INSERT INTO `boa_role_menu` VALUES (1, 37);
INSERT INTO `boa_role_menu` VALUES (1, 38);
INSERT INTO `boa_role_menu` VALUES (1, 39);
INSERT INTO `boa_role_menu` VALUES (1, 40);
INSERT INTO `boa_role_menu` VALUES (1, 41);
INSERT INTO `boa_role_menu` VALUES (1, 42);
INSERT INTO `boa_role_menu` VALUES (1, 43);
INSERT INTO `boa_role_menu` VALUES (1, 44);
INSERT INTO `boa_role_menu` VALUES (1, 45);
INSERT INTO `boa_role_menu` VALUES (1, 46);
INSERT INTO `boa_role_menu` VALUES (1, 47);
INSERT INTO `boa_role_menu` VALUES (1, 48);
INSERT INTO `boa_role_menu` VALUES (1, 49);
INSERT INTO `boa_role_menu` VALUES (1, 50);
INSERT INTO `boa_role_menu` VALUES (1, 51);
INSERT INTO `boa_role_menu` VALUES (1, 59);
INSERT INTO `boa_role_menu` VALUES (1, 60);
INSERT INTO `boa_role_menu` VALUES (2, 1);
INSERT INTO `boa_role_menu` VALUES (2, 2);
INSERT INTO `boa_role_menu` VALUES (2, 3);
INSERT INTO `boa_role_menu` VALUES (2, 4);
INSERT INTO `boa_role_menu` VALUES (2, 5);
INSERT INTO `boa_role_menu` VALUES (2, 6);
INSERT INTO `boa_role_menu` VALUES (2, 7);
INSERT INTO `boa_role_menu` VALUES (2, 8);
INSERT INTO `boa_role_menu` VALUES (2, 9);
INSERT INTO `boa_role_menu` VALUES (2, 10);
INSERT INTO `boa_role_menu` VALUES (2, 11);
INSERT INTO `boa_role_menu` VALUES (2, 12);
INSERT INTO `boa_role_menu` VALUES (2, 13);
INSERT INTO `boa_role_menu` VALUES (2, 14);
INSERT INTO `boa_role_menu` VALUES (2, 15);
INSERT INTO `boa_role_menu` VALUES (2, 16);
INSERT INTO `boa_role_menu` VALUES (2, 17);
INSERT INTO `boa_role_menu` VALUES (2, 18);
INSERT INTO `boa_role_menu` VALUES (2, 19);
INSERT INTO `boa_role_menu` VALUES (2, 20);
INSERT INTO `boa_role_menu` VALUES (2, 21);
INSERT INTO `boa_role_menu` VALUES (2, 22);
INSERT INTO `boa_role_menu` VALUES (2, 23);
INSERT INTO `boa_role_menu` VALUES (2, 24);
INSERT INTO `boa_role_menu` VALUES (2, 25);
INSERT INTO `boa_role_menu` VALUES (2, 26);
INSERT INTO `boa_role_menu` VALUES (2, 27);
INSERT INTO `boa_role_menu` VALUES (2, 28);
INSERT INTO `boa_role_menu` VALUES (2, 29);
INSERT INTO `boa_role_menu` VALUES (2, 30);
INSERT INTO `boa_role_menu` VALUES (2, 31);
INSERT INTO `boa_role_menu` VALUES (2, 32);
INSERT INTO `boa_role_menu` VALUES (2, 33);
INSERT INTO `boa_role_menu` VALUES (2, 36);
INSERT INTO `boa_role_menu` VALUES (2, 37);
INSERT INTO `boa_role_menu` VALUES (2, 38);
INSERT INTO `boa_role_menu` VALUES (2, 39);
INSERT INTO `boa_role_menu` VALUES (2, 40);
INSERT INTO `boa_role_menu` VALUES (2, 41);
INSERT INTO `boa_role_menu` VALUES (2, 42);
INSERT INTO `boa_role_menu` VALUES (2, 43);
INSERT INTO `boa_role_menu` VALUES (2, 44);
INSERT INTO `boa_role_menu` VALUES (2, 45);
INSERT INTO `boa_role_menu` VALUES (2, 46);
INSERT INTO `boa_role_menu` VALUES (2, 47);
INSERT INTO `boa_role_menu` VALUES (2, 48);
INSERT INTO `boa_role_menu` VALUES (2, 49);
INSERT INTO `boa_role_menu` VALUES (2, 50);
INSERT INTO `boa_role_menu` VALUES (2, 51);
INSERT INTO `boa_role_menu` VALUES (2, 59);
INSERT INTO `boa_role_menu` VALUES (2, 60);
COMMIT;

-- ----------------------------
-- Table structure for boa_user
-- ----------------------------
DROP TABLE IF EXISTS `boa_user`;
CREATE TABLE `boa_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `login_name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '登录帐号',
  `user_name` varchar(30) COLLATE utf8mb4_bin DEFAULT '' COMMENT '用户昵称',
  `user_type` varchar(2) COLLATE utf8mb4_bin DEFAULT '00' COMMENT '用户类型（00系统用户 01注册用户）',
  `email` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) COLLATE utf8mb4_bin DEFAULT '' COMMENT '手机号码',
  `sex` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '头像路径',
  `password` varchar(100) COLLATE utf8mb4_bin DEFAULT '' COMMENT '密码',
  `salt` varchar(20) COLLATE utf8mb4_bin DEFAULT '' COMMENT '盐加密',
  `status` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `login_ip` varchar(128) COLLATE utf8mb4_bin DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `pwd_update_date` datetime DEFAULT NULL COMMENT '密码最后更新时间',
  `create_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `job_number` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '工号',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统管理-用户信息表';

-- ----------------------------
-- Records of boa_user
-- ----------------------------
BEGIN;
INSERT INTO `boa_user` VALUES (1, 16, 'admin', '若依1', '00', 'ry@163.com', '15888888888', '0', '', 'bmadmin', '', '0', '1', '127.0.0.1', '2022-03-16 08:54:37', '2022-03-16 08:54:37', 'admin', '2022-03-16 08:54:37', 'admin222', '2022-09-07 11:14:23', '管理员', NULL);
INSERT INTO `boa_user` VALUES (2, 16, 'ry333323', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '8e6d98b90472783cc73c17047ddccf36', '', '0', '1', '127.0.0.1', '2022-03-16 08:54:37', '2022-03-16 08:54:37', 'admin', '2022-03-16 08:54:37', 'litianping', '2022-10-09 15:57:54', '测试员', '2332333');
INSERT INTO `boa_user` VALUES (104, 1, 'root2222', 'mingcheng', '00', '444', '555', '2', '1', '777', '', '1', '1', '', '2022-03-18 14:54:00', '2022-03-18 14:54:00', '', '2022-03-18 14:54:00', '', '2022-03-24 10:48:33', '', NULL);
INSERT INTO `boa_user` VALUES (105, 1, '111', '222', '00', '444', '555', '2', '1', '777', '', '1', '1', '', '2022-03-24 10:46:58', '2022-03-24 10:46:58', '', '2022-03-24 10:46:58', '', '2022-03-24 10:46:58', '', NULL);
INSERT INTO `boa_user` VALUES (107, 16, 'testdev1', '张三1', '00', 'test@bm.com', '12328394851', '1', '', '123456', '', '0', '1', NULL, NULL, NULL, NULL, '2022-08-02 11:13:59', 'litianping', '2022-09-06 14:21:11', '9', NULL);
INSERT INTO `boa_user` VALUES (108, 0, '1', '1', '00', '1', '1', '0', NULL, '656484a6279d6784ef745c304acbf11c89d5cebefe133611a00998987014c5d167632c414268a4bfd50fc86a681318ff901c', '4osHKwN9Tw', '0', '1', NULL, NULL, NULL, NULL, '2022-09-06 11:20:47', NULL, '2022-09-06 11:20:47', NULL, NULL);
INSERT INTO `boa_user` VALUES (109, 0, 'accoubt', '12', '00', '123', '13531009443', '0', NULL, '6908a6a176872f22d6e446e953da8215ad0bbbe650facf3c89c6a366f581b9f6957787e3fe5201633a3b69b75739fdeef2e5', 'yZAKS2Y16Q', '0', '1', NULL, NULL, NULL, NULL, '2022-09-06 11:56:25', NULL, '2022-09-06 11:56:25', NULL, NULL);
INSERT INTO `boa_user` VALUES (110, 0, '134', '424', '00', '24', '124', '0', NULL, 'f180054dab0c60a5210f4c7764fc791effc0d05dd52f0b05538ef770ae850576555b0d6003979e1231f5294137dfe56b0a53', 'Mbdu0Yxs85', '0', '1', NULL, NULL, NULL, NULL, '2022-09-06 13:17:16', NULL, '2022-09-06 14:28:33', NULL, NULL);
INSERT INTO `boa_user` VALUES (111, 19, 'admin12', '1313', '01', '131@qq.com', '13531009665', '0', NULL, '852aa592d2d6465429406f24fbea976cfe8ce85648b22cf8461c6d3e1f62128d7e42d1a355db864eb0214b0310701e0368bc', 'SVnxapyx0X', '0', '1', NULL, NULL, NULL, NULL, '2022-09-06 15:06:11', 'litianping', '2022-10-09 16:01:09', '131', '12345678');
INSERT INTO `boa_user` VALUES (120, 16, 'accoubt', '12', '00', '123', '13531009443', '0', NULL, '3ff68ce5268040896f90e9b5b93b764bd98d4b52166d59c72d9410a065ca2f6cd2d732f91edafe4bace87b3d23cb23e6632c', 'vVs63KQ3xy', '0', '1', NULL, NULL, NULL, NULL, '2022-09-06 16:49:42', NULL, '2022-09-06 16:49:42', NULL, NULL);
INSERT INTO `boa_user` VALUES (121, 16, '11111', '系统', '00', '134', '134', '0', NULL, 'b71ec24d790802e20f79ec6b0ec849e2784424382d5a8f2013fa7ed98a1e1b3633b493cde6c7deb550ca161d8661fbc81663', 'X4N8d1xc7Z', '0', '1', NULL, NULL, NULL, NULL, '2022-09-07 10:01:24', NULL, '2022-09-07 10:01:24', NULL, NULL);
INSERT INTO `boa_user` VALUES (122, 16, '121', '3', '00', '131', '313', '0', NULL, 'cf25a8eef472aa333a00861331ec982f638a0464c00d4f68bdb2db2ab59cf06527449b714eb0f29df4d8338568589ea0c2e7', '4oqnTr6dS6', '0', '1', NULL, NULL, NULL, NULL, '2022-09-07 10:46:46', NULL, '2022-09-07 10:46:46', NULL, NULL);
INSERT INTO `boa_user` VALUES (123, 14, '1', '1', '00', '14', '1434', '0', NULL, 'b8569ff2e48c92520c09634cb16482d586b665294dbc8df83237be55effb3f9408db661b2400974c04bc6249714f1c4834e2', 'J3DkJw0c55', '0', '1', NULL, NULL, NULL, NULL, '2022-09-07 11:14:48', NULL, '2022-09-07 11:14:48', NULL, NULL);
INSERT INTO `boa_user` VALUES (124, 16, 'admin', 'admin', '00', '11', '11', '0', NULL, 'bmadmin', '4oSaIBqTqy', '0', '0', NULL, NULL, NULL, NULL, '2022-09-07 11:15:34', NULL, '2022-09-07 11:15:34', NULL, NULL);
INSERT INTO `boa_user` VALUES (125, 16, 'admin13', '34134', '00', '134@qq.com', '13551009885', '0', NULL, 'efed648b882e485f266a0042af70b0cf9bc5ef0ee985feb3ac1527a68393e23a9393cec7f6158b270cd44674d7a2df9152e4', 'BG31XmuMJN', '0', '1', NULL, NULL, NULL, 'admin', '2022-10-09 15:58:41', 'litianping', '2022-10-09 15:58:41', NULL, '1344');
INSERT INTO `boa_user` VALUES (126, 19, 'bm81004842', '李天平', '00', 'litianping@bluemoon.com.cn', '15917397741', '0', NULL, '599bd779c890f355c49ec740ab9ac436b1b70b41a66e4488512f82ce2bad51747d506cbe3f828133e2e870b6a2f2d15f682c', '1Jfvzf2j0m', '0', '0', NULL, NULL, NULL, 'admin', '2022-10-12 09:54:52', 'admin', '2022-10-13 16:45:09', NULL, '81004842');
INSERT INTO `boa_user` VALUES (127, 19, 'bm80549776', '李浚康', '00', 'lijunkang@bluemoon.com.cn', '18826232993', '0', NULL, '1c8722ea39b0d14544d4a183921c00d89bb0fe654529bc13079da92abe8d6496231facac50e67362c925d73bd5f4132703f5', 'zJEST3r1u2', '0', '0', NULL, NULL, NULL, 'admin', '2022-10-12 10:04:50', 'admin', '2022-10-12 10:04:50', NULL, '80549776');
INSERT INTO `boa_user` VALUES (128, 19, 'bm80530629', '石伟森', '00', 'shiweisen@bluemoon.com.cn', '13427696177', '0', NULL, '48efe0926af75e8829675e2b7f4062a3733abf24ac8d7313f32e1bc833d0f0bcbaf5d9b3d525b41368b904993973163ba308', 'F3yDHSZlD6', '0', '0', NULL, NULL, NULL, 'admin', '2022-10-12 10:06:35', '李浚康', '2022-10-12 10:15:02', NULL, '80530629');
INSERT INTO `boa_user` VALUES (129, 19, 'bm80486838', '徐海望', '00', 'xuhaiwang@bluemoon.com.cn', '18688468615', '0', NULL, '5eedd169bd0a6e7f2c4c229e4fb1fb4268d26a8036b25fd7fea473a46f956646076e1941016d38157790f8ebb5c533306e72', 'WwUkAt31Om', '0', '0', NULL, NULL, NULL, 'admin', '2022-10-12 10:07:21', 'admin', '2022-10-12 10:07:21', NULL, '80486838');
INSERT INTO `boa_user` VALUES (130, 19, 'bm80544797', '李代宁', '00', 'lidaining@bluemoon.com.cn', '13570475605', '0', NULL, 'cef9e1e51f89924338d3dd5a6598f7d90582b447e586538f61f2d270e5a5974d747b079ad6ed2daee029a6157bf7c6f05424', 'JZbm7bd2Z0', '0', '0', NULL, NULL, NULL, 'admin', '2022-10-12 10:09:35', 'admin', '2022-10-12 10:09:35', NULL, '80544797');
INSERT INTO `boa_user` VALUES (131, 21, 'bm80548157', '陈婉仪', '00', 'chenwanyi@bluemoon.com.cn', '13430340604', '1', NULL, '28b79e3fd5adf1c7d577064d8238538f80b719c4005e473a63eee0815aa84a4c4d2b90f72959187687bf841d5d3060977526', '7fdDvqPgwe', '0', '0', NULL, NULL, NULL, 'admin', '2022-10-12 14:55:19', 'admin', '2022-10-12 15:06:46', NULL, '80548157');
INSERT INTO `boa_user` VALUES (132, 17, 'manager', '分级管理员', '01', '123456789@qq.com', '13727696199', '0', NULL, 'cd41869b15a0b0712708c44cad268b9dd17c0f6fd73ec66c87112feba353e541aa1dadc85d8be73ae0cabfe15491f298f9ea', '3Ep1me4deV', '0', '0', NULL, NULL, NULL, 'admin', '2023-05-31 14:04:06', 'admin', '2023-05-31 14:04:25', '分级管理员', '80530628');
COMMIT;

-- ----------------------------
-- Table structure for boa_user_role
-- ----------------------------
DROP TABLE IF EXISTS `boa_user_role`;
CREATE TABLE `boa_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统管理-用户和角色关联表';

-- ----------------------------
-- Records of boa_user_role
-- ----------------------------
BEGIN;
INSERT INTO `boa_user_role` VALUES (124, 1);
INSERT INTO `boa_user_role` VALUES (124, 2);
INSERT INTO `boa_user_role` VALUES (126, 1);
INSERT INTO `boa_user_role` VALUES (127, 1);
INSERT INTO `boa_user_role` VALUES (128, 1);
INSERT INTO `boa_user_role` VALUES (129, 1);
INSERT INTO `boa_user_role` VALUES (130, 1);
INSERT INTO `boa_user_role` VALUES (131, 1);
INSERT INTO `boa_user_role` VALUES (131, 2);
INSERT INTO `boa_user_role` VALUES (132, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
